zeroimmunizationfollowupdetails
Table: zeroimmunizationfollowupdetails
The zeroimmunizationfollowupdetails table stores follow-up visit details for zero-immunization children.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| id | bigint(20) | NO | Primary key |
| createdDate | datetime | YES | Timestamp when the record was created |
| lastEditedDate | datetime | YES | Timestamp when the record was last edited |
| details | varchar(255) | YES | Notes or details of the follow-up |
| status | varchar(20) | YES | Status of follow-up |
| visitDate | datetime | YES | Date of follow-up visit |
| zeroImmunizationChildId | int(11) | YES | Reference to zero-immunization child |
| createdByUserId | int(11) | YES | User who created the record |
| lastEditedByUserId | int(11) | YES | User who last edited the record |
Indexes
fridgeTag_createdByUserId_user_mappedId_FK— Index oncreatedByUserIdfridgeTag_lastEditedByUserId_user_mappedId_FK— Index onlastEditedByUserId
Foreign Key Relations
createdByUserId → user.mappedIdlastEditedByUserId → user.mappedId
Usage Notes
- Stores detailed follow-up information to track outreach success.